/*
 Navicat Premium Data Transfer

 Source Server         : 本地
 Source Server Type    : MySQL
 Source Server Version : 80020
 Source Host           : localhost:3306
 Source Schema         : ers

 Target Server Type    : MySQL
 Target Server Version : 80020
 File Encoding         : 65001

 Date: 03/07/2022 21:12:05
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for product_category
-- ----------------------------
DROP TABLE IF EXISTS `product_category`;
CREATE TABLE `product_category` (
  `id` int NOT NULL AUTO_INCREMENT COMMENT '主键',
  `name` varchar(50) NOT NULL DEFAULT '' COMMENT '分类目录名称',
  `type` int NOT NULL DEFAULT '0' COMMENT '分类目录级别,例如1表示一级,2表示二级,3表示三级',
  `parent_id` int NOT NULL COMMENT '父id,也就是上一级目录的id,二级目录的父id是1,一级目录的id是0',
  `order_num` int NOT NULL COMMENT '目录展示时的排序',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=27 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='商品分类';

-- ----------------------------
-- Records of product_category
-- ----------------------------
BEGIN;
INSERT INTO `product_category` VALUES (1, '冷菜类', 1, 0, 1);
INSERT INTO `product_category` VALUES (2, '酒水类', 1, 0, 2);
INSERT INTO `product_category` VALUES (3, '饮料类', 1, 0, 3);
INSERT INTO `product_category` VALUES (4, '小吃类', 1, 0, 4);
INSERT INTO `product_category` VALUES (5, '豆腐类', 1, 0, 5);
INSERT INTO `product_category` VALUES (6, '蒸菜类', 1, 0, 6);
INSERT INTO `product_category` VALUES (7, '时蔬类', 1, 0, 7);
INSERT INTO `product_category` VALUES (8, '甜品类', 1, 0, 8);
INSERT INTO `product_category` VALUES (9, '汤锅类', 1, 0, 9);
INSERT INTO `product_category` VALUES (10, '西餐类', 1, 0, 10);
INSERT INTO `product_category` VALUES (11, '凉拌茄子', 2, 1, 1);
INSERT INTO `product_category` VALUES (12, '凉拌木耳', 2, 1, 2);
INSERT INTO `product_category` VALUES (13, '雪花啤酒', 2, 2, 1);
INSERT INTO `product_category` VALUES (14, '二锅头', 2, 2, 2);
INSERT INTO `product_category` VALUES (15, '雪碧', 2, 3, 1);
INSERT INTO `product_category` VALUES (16, '可乐', 2, 3, 2);
INSERT INTO `product_category` VALUES (17, '红糖糍粑', 2, 4, 1);
INSERT INTO `product_category` VALUES (18, '南瓜饼', 2, 4, 2);
INSERT INTO `product_category` VALUES (19, '宫保日本豆腐', 2, 5, 1);
INSERT INTO `product_category` VALUES (20, '麻婆豆腐', 2, 5, 2);
INSERT INTO `product_category` VALUES (21, '粉蒸肉', 2, 6, 1);
INSERT INTO `product_category` VALUES (22, '老盐菜烧白', 2, 6, 2);
INSERT INTO `product_category` VALUES (23, '空心菜', 2, 7, 1);
INSERT INTO `product_category` VALUES (24, '奶油蛋糕', 2, 8, 1);
INSERT INTO `product_category` VALUES (25, '牛肉汤锅', 2, 9, 1);
INSERT INTO `product_category` VALUES (26, '披萨', 2, 10, 1);
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
